Weekly analytics and reporting

Below is a summary of how many hospital records were loaded in the most recent week, and how that compares to previous weeks:

Hospital Records Over Week

Number of Records	Load Week
4985	2022-10-21
4995	2022-09-23
4995	2022-10-14
4997	2022-09-30
4996	2022-10-07

Below are tables summarizing the number of adult and pediatric beds available this week, the number used, and the number used by patients with COVID, compared to the 4 most recent weeks:

Adult Summarization

SUM_available_beds	AVG_available_beds	STD_available_beds	SUM_used_beds	AVG_used_beds	STD_used_beds	Week
414880.30	197.22	147.23	34376.00	6.90	0.53	2022-10-21
412939.00	195.46	146.22	34841.00	6.98	0.29	2022-10-14
415465.40	195.97	145.83	34886.00	6.98	0.26	2022-10-07
416279.40	195.97	145.40	34852.00	6.97	0.28	2022-09-30
413559.50	194.16	145.36	34825.00	6.97	0.32	2022-09-23

Pediadric Summarization

SUM_available_beds	AVG_available_beds	STD_available_beds	SUM_used_beds	AVG_used_beds	STD_used_beds	Week
39882.20	36.90	8.78	29706.50	6.82	32.38	2022-10-21
39711.60	36.61	8.69	28799.00	6.58	31.55	2022-10-14
39796.80	36.78	8.70	28285.80	6.47	31.46	2022-10-07
39804.70	36.63	8.72	28042.80	6.40	31.23	2022-09-30
39605.50	36.13	8.68	27778.10	6.37	30.59	2022-09-23

Covid beds Summarization

SUM_used_beds	AVG_used_beds	STD_used_beds	Week
24116.80	7.87	14.94	2022-10-21
23695.50	7.76	14.77	2022-10-14
23689.30	7.64	14.35	2022-10-07
24142.50	7.92	14.37	2022-09-30
25600.60	8.31	14.57	2022-09-23

Graphs summarizing the fraction of beds currently in use by hospital quality rating:

A plot of the total number of hospital beds used per week, over all time:

Below is a map showing the number of COVID cases by state:

A table of hospitals that did not report any data in the past week, their names, and the date they most recently reported data:

No Report Hospitals

ID	Name	Last Report Week
351325	ST LUKE'S HOSPITAL	2022-10-07
371331	DRUMRIGHT REGIONAL HOSPITAL	2022-10-14
451394	KNOX COUNTY HOSPITAL	2022-10-14
531308	JOHNSON COUNTY HEALTHCARE CENTER	2022-09-30
140133	HOLY CROSS HOSPITAL	2022-10-14
031317	LA PAZ REGIONAL HOSPITAL	2022-10-14
140018	MT SINAI HOSPITAL MEDICAL CENTER	2022-10-14
160008	KEOKUK AREA HOSPITAL	2022-09-23
020008	BARTLETT REGIONAL HOSPITAL	2022-10-14
141306	COMMUNITY HOSPITAL OF STAUNTON	2022-10-14
370225	SUMMIT MEDICAL CENTER, LLC	2022-10-14
281309	SYRACUSE AREA HEALTH	2022-10-14
351320	UNITY MEDICAL CENTER	2022-10-14
250027	WINSTON MEDICAL CENTER & SWINGBED	2022-10-14
141323	MASSAC MEMORIAL HOSPITAL	2022-10-14
370166	WAGONER COMMUNITY HOSPITAL	2022-10-14

Graphs of ICU hospital utilization by state over time:

Graphs of ICU hospital utilization by ownership over time: